"""
Copyright (c) 2022 Huawei Technologies Co.,Ltd.

openGauss is licensed under Mulan PSL v2.
You can use this software according to the terms and conditions of the Mulan PSL v2.
You may obtain a copy of Mulan PSL v2 at:

          http://license.coscl.org.cn/MulanPSL2

THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
See the Mulan PSL v2 for more details.
"""
"""
Case Type   : 故障&可靠性测试
Case Name   : 备节点备份过程中停止主节点-h指向主节点
Create At   : 2020/12/1
@zou_jialiang0505328126
Description :
    1.备节点执行备份-h指向主节点
    2.备份过程中停止主节点
    3.修改主节点recovery_max_workers为5
    4.恢复主节点
    5.查询recovery_max_workers值
Expect      :
    1.备份成功
    2.停止主节点成功
    3.修改参数成功
    4.恢复主节点成功
    5.查询参数值为4
History     :
"""

import os
import unittest
import sys
from yat.test import macro
from yat.test import Node

sys.path.append(sys.path[0] + "/../")
from testcase.utils.CommonSH import *
from testcase.utils.Common import Common
from testcase.utils.Constant import Constant
from testcase.utils.Logger import Logger
from testcase.utils.ComThread import ComThread


class Basebackup(unittest.TestCase):
    commonshpri = CommonSH('PrimaryDbUser')
    commonshsta = CommonSH('Standby1DbUser')
    commonshsta2 = CommonSH('Standby2DbUser')
    nodes_tuple = ('PrimaryDbUser', 'Standby1DbUser', 'Standby2DbUser')

    @RestartDbCluster(*nodes_tuple)
    def setUp(self):
        self.log = Logger()
        self.log.info('------------Opengauss_Reliability_Tools_Backup_Case027.py 开始执行------------')
        self.dbPrimaryDbUser = Node(node='PrimaryDbUser')
        self.dbStandby1DbUser = Node(node='Standby1DbUser')
        self.dbStandby2DbUser = Node(node='Standby2DbUser')
        self.dbStandby1Root = Node(node='Standby1Root')
        self.dbPrimaryRootNode = Node(node='PrimaryRoot')
        self.Constant = Constant()
        self.common = Common('PrimaryRoot')
        self.backup_file = os.path.join(macro.DB_BACKUP_PATH, 'backup_dir')
        self.primary_hostname = self.dbPrimaryDbUser.sh('hostname').result()

        self.log.info('-------------------创建备份路径-----------------------------------')
        shell_cmd = f'rm -rf {self.backup_file}; mkdir {self.backup_file};'
        self.log.info(shell_cmd)
        result = self.dbPrimaryDbUser.sh(shell_cmd).result()
        self.log.info(result)

    def test_backup(self):
        self.log.info("-----------------------------1.备节点执行备份-h指向主节点：成功---------------------------------")
        backup_thread = ComThread(self.commonshsta.execu_gs_backup,
                                   args=('backup', self.primary_hostname, self.backup_file, "--all",))
        backup_thread.setDaemon(True)
        backup_thread.start()

        self.log.info('-----------------------------2.备份过程中停止主节点:成功------------------------------')
        result = self.commonshpri.stopDbInstance()
        self.assertTrue(result)

        self.log.info('==================检查步骤1结果================')
        backup_thread.join(20 * 60)
        result = backup_thread.get_result()
        self.log.info(result)
        self.assertIn(self.Constant.BACKUP_BACKUP_SUCCESS_MSG, result)
        cmd = f'ls -l {self.backup_file} |grep "^-"|wc -l'
        self.log.info(cmd)
        result = self.dbPrimaryRootNode.sh(cmd).result()
        self.log.info(result)
        self.assertLess(0, int(result))

        self.log.info("------------------------3.修改主节点recovery_max_workers为5:成功--------------------------")
        result = self.commonshpri.executeGsguc('set', self.Constant.GSGUC_SUCCESS_MSG, 'recovery_max_workers=5',
                                               self.primary_hostname)
        self.assertTrue(result)
        result = self.commonshpri.startDbInstance()
        self.assertIn(self.Constant.RESTART_SUCCESS_MSG, result)
        result = self.commonshpri.executeGsguc('check', '5', 'recovery_max_workers', self.primary_hostname)
        self.assertTrue(result)

        self.log.info('-------------------4.恢复主节点:成功-----------------------------------')
        result = self.commonshsta.execu_gs_backup('restore', self.primary_hostname, self.backup_file, "--all")
        self.assertIn(self.Constant.BACKUP_RESTORE_SUCCESS_MSG, result)

        self.log.info('-------------------5.检查recovery_max_workers参数:成功------------------------')
        result = self.commonshpri.executeGsguc('check', '4', 'recovery_max_workers', self.primary_hostname)
        self.assertTrue(result)

    def tearDown(self):
        self.log.info('-------------------------环境清理------------------------')
        self.log.info('--------------------------删除备份文件------------------')
        shell_cmd = f'rm -rf {self.backup_file}'
        self.log.info(shell_cmd)
        result = self.dbPrimaryDbUser.sh(shell_cmd).result()
        self.log.info(result)
        result = self.dbStandby1DbUser.sh(shell_cmd).result()
        self.log.info(result)
        result = self.dbStandby2DbUser.sh(shell_cmd).result()
        self.log.info(result)


        self.log.info('----------------------------恢复recovery_max_workers-----------------')
        result = self.commonshpri.executeGsguc('check', '4', 'recovery_max_workers', self.primary_hostname)
        if not result:
            result = self.commonshpri.executeGsguc('set', self.Constant.GSGUC_SUCCESS_MSG, 'recovery_max_workers=4',
                                                   self.primary_hostname)
            self.log.info(str(result))
            result = self.commonshpri.stopDbCluster()
            self.log.info(result)
            result = self.commonshpri.startDbCluster()
            self.log.info(result)

        self.log.info('----------Opengauss_Reliability_Tools_Backup_Case027.py 执行结束-----------------------')

